DROP TABLE IF EXISTS jms_ods.yl_oms_waybill_out_count ;
CREATE EXTERNAL TABLE jms_ods.yl_oms_waybill_out_count (
COLLECTIONNETWORKNAME          string          comment     '揽收网点名称'     ,         --NVARCHAR2(128)
COLLECTIONNETWORKCODE          string          comment     '揽收网点名称'     ,         --NVARCHAR2(64)
INPUTTIME          timestamp          comment     '揽收时间'     ,         --DATE
SIGNPROPORTION          string          comment     '签收占比'     ,         --VARCHAR2(41)
NOSIGNPROPORTION          string          comment     '未签收暂占比'     ,         --VARCHAR2(41)
COLLECTQUANTITY          bigint          comment     '揽收数量'     ,         --NUMBER(10)
SIGNQUANTITY          bigint          comment     '签收数量'     ,         --NUMBER(10)
NOSIGN          bigint          comment     '未签收数量'     ,         --NUMBER(10)
CITYTOTAL          bigint          comment     '市内总票数'     ,         --NUMBER(10)
CITYNOSIGNQUANTITY          bigint          comment     '市内未签收刷量'     ,         --NUMBER(10)
CITYSIGNQUANTITY          bigint          comment     '市内签收数量'     ,         --NUMBER(10)
CITYSIGNINTRADAYQUANTITY          bigint          comment     '市内当天签收数量'     ,         --NUMBER(10)
CITYSIGNONEDAYQUANTITY          bigint          comment     '市内第一天签收数量'     ,         --NUMBER(10)
CITYSIGNSECONDDAYQUANTITY          bigint          comment     '市内第二天签收数量'     ,         --NUMBER(10)
CITYSIGNSECONDDAYDAYQUANTITY_          bigint          comment     '市内第二天后签收数量'     ,         --NUMBER(10)
AREATOTAL          bigint          comment     '区内总票数'     ,         --NUMBER(10)
AREANOSIGNQUANTITY          bigint          comment     '区内未签收数量'     ,         --NUMBER(10)
AREASIGNQUANTITY          bigint          comment     '区内签收数量'     ,         --NUMBER(10)
AREASIGNONEDAYQUANTITY          bigint          comment     '区内当天签收数量'     ,         --NUMBER(10)
AREASIGNSECONDDAYQUANTITY          bigint          comment     '区内第二天签收数量'     ,         --NUMBER(10)
AREASIGNTHIRDLYDAYQUANTITY          bigint          comment     '区内第三天签收数量'     ,         --NUMBER(10)
AREASIGNTHIRDLYDAYQUANTITY_          bigint          comment     '区内第三天后签收数量'     ,         --NUMBER(10)
OTHERTOTAL          bigint          comment     '区外总票数'     ,         --NUMBER(10)
OUTAREANOSIGNQUANTITY          bigint          comment     '区外未签收数量'     ,         --NUMBER(10)
OUTAREASIGNQUANTITY          bigint          comment     '区外签收数量'     ,         --NUMBER(10)
OUTAREASIGNONEDAYQUANTITY          bigint          comment     '区外第一天签收数量'     ,         --NUMBER(10)
OUTAREASIGNTHIRDLYDAYQUANTITY          bigint          comment     '区外第三天签收数量'     ,         --NUMBER(10)
OUTAREASIGNSEVENDAYQUANTITY          bigint          comment     '区外第七天签收数量'     ,         --NUMBER(10)
OUTAREASIGNSEVENDAYQUANTITY_          bigint          comment     '区外第七天后签收数量'     ,         --NUMBER(10)
CREATE_TIME          timestamp          comment     '创建时间'     ,         --DATE
UPDATE_TIME          timestamp          comment     '更新时间'              --DATE
)
    COMMENT  '出港时效监控聚合表信息合并'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/yl_oms_waybill_out_count'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

MSCK REPAIR TABLE jms_ods.yl_oms_waybill_out_count;
